select 2500/60

select min(StartTime) [Oldest Row]
  , max(StartTime) [Newest Row]
  , count(*) [count]
  , min(reads) [Min Reads]
  , avg(reads) [Avg Reads]
  , max(reads) [Max Reads]
  , min(writes) [Min Writes]
  , avg(writes) [Avg Writes]
  , max(writes) [Max Writes]
  , min(cpu) [Min CPU]
  , avg(cpu) [Avg CPU]
  , max(cpu) [Max CPU]
  , min(duration) [Min Duration]
  , avg(duration) [Avg Duration]
  , max(duration) [Max Duration]
  , cast('Create table only' as varchar(7000)) [SQL]
into admin.dbo.list
from admin.dbo.traceZEUS310 
where 1=2

insert admin.dbo.list
select min(StartTime)
  , max(StartTime)
  , count(*) [count]
  , min(reads) [Min Reads]
  , avg(reads) [Avg Reads]
  , max(reads) [Max Reads]
  , min(writes) [Min Writes]
  , avg(writes) [Avg Writes]
  , max(writes) [Max Writes]
  , min(cpu) [Min CPU]
  , avg(cpu) [Avg CPU]
  , max(cpu) [Max CPU]
  , min(duration) [Min Duration]
  , avg(duration) [Avg Duration]
  , max(duration) [Max Duration]
  ,case grouping(p.ProcedureName) when 1 then 'TOTAL CACHED' else p.Procedurename end
from admin.dbo.traceZEUS310 t
join lnkbz.admin.dbo.ProceduresFoundInCache p
on charindex(p.ProcedureName,t.TextData) > 0
where StartTime is not null
group by p.ProcedureName
with rollup
order by p.ProcedureName

insert admin.dbo.list
select min(StartTime)
  , max(StartTime)
  , count(*) [count]
  , min(reads) [Min Reads]
  , avg(reads) [Avg Reads]
  , max(reads) [Max Reads]
  , min(writes) [Min Writes]
  , avg(writes) [Avg Writes]
  , max(writes) [Max Writes]
  , min(cpu) [Min CPU]
  , avg(cpu) [Avg CPU]
  , max(cpu) [Max CPU]
  , min(duration) [Min Duration]
  , avg(duration) [Avg Duration]
  , max(duration) [Max Duration]
  , case grouping(t.TextData) when 1 then 'TOTAL NON-CACHED' else t.TextData end
from admin.dbo.traceZEUS310 t
left join lnkbz.admin.dbo.ProceduresFoundInCache p
on charindex(p.ProcedureName,t.TextData) > 0
where StartTime is not null
and p.ProcedureName is null
group by t.TextData
with rollup
order by t.TextData

update admin.dbo.list
set SQL = 'TOTAL CACHED' 
where SQL = 'Summary'

select [Oldest Row]
  , [Newest Row]
  , [count]
  , [Min Reads]
  , [Avg Reads]
  , [Max Reads]
  , [Min Writes]
  , [Avg Writes]
  , [Max Writes]
  , [Min CPU]
  , [Avg CPU]
  , [Max CPU]
  , [Min Duration]
  , [Avg Duration]
  , [Max Duration]
  , SQL
from admin.dbo.list 
where SQL = 'Summary'
or SQL like 'TOTAL %'

select sum(count) from list
where SQL <> 'Summary'
and SQL not like 'TOTAL %'

select sum(cast(count as numeric(18,2))) [count]
                 , sum([Avg Reads]) * sum(cast(count as numeric(18,2))) [Sum Avg Reads]
                 , sum([Max Reads]) * sum(cast(count as numeric(18,2))) [Sum Max Reads]
                 , sum([Avg Writes]) * sum(cast(count as numeric(18,2))) [Sum Avg Writes]
                 , sum([Max Writes]) * sum(cast(count as numeric(18,2))) [Sum Max Writes]
                 , sum([Avg CPU]) * sum(cast(count as numeric(18,2))) [Sum Avg CPU]
                 , sum([Max CPU]) * sum(cast(count as numeric(18,2))) [Sum Max CPU]
                 , sum([Avg Duration]) * sum(cast(count as numeric(18,2))) [Sum Avg Duration]
                 , sum([Max Duration]) * sum(cast(count as numeric(18,2))) [Sum Max Duration]
              from admin.dbo.list
              where SQL not like 'TOTAL %'

select l1.SQL
  , l1.count
  , l1.count/l2.count [% of queries]
  , l1.[Avg Reads], l1.[Avg Reads]*l1.[count] [Sum Avg Reads]
  , l1.[Avg Reads]*l1.[count]/l2.[Sum Avg Reads] [% Avg Reads]
  , l1.[Max Reads], l1.[Max Reads]*l1.[count] [Sum Max Reads]
  , l1.[Max Reads]*l1.[count]/l2.[Sum Max Reads] [% Max Reads]
  , l1.[Avg Writes], l1.[Avg Writes]*l1.[count] [Sum Avg Writes]
  , l1.[Avg Writes]*l1.[count]/l2.[Sum Avg Writes] [% Avg Writes]
  , l1.[Max Writes], l1.[Max Writes]*l1.[count] [Sum Max Writes]
  , l1.[Max Writes]*l1.[count]/l2.[Sum Max Writes] [% Max Writes]
  , l1.[Avg CPU], l1.[Avg CPU]*l1.[count] [Sum Avg CPU]
  , l1.[Avg CPU]*l1.[count]/l2.[Sum Avg CPU] [% Avg CPU]
  , l1.[Max CPU], l1.[Max CPU]*l1.[count] [Sum Max CPU]
  , l1.[Max CPU]*l1.[count]/l2.[Sum Max CPU] [% Max CPU]
  , l1.[Avg Duration], l1.[Avg Duration]*l1.[count] [Sum Avg Duration]
  , l1.[Avg Duration]*l1.[count]/l2.[Sum Avg Duration] [% Avg Duration]
  , l1.[Max Duration], l1.[Max Duration]*l1.[count] [Sum Max Duration]
  , l1.[Max Duration]*l1.[count]/l2.[Sum Max Duration] [% Max Duration]
from admin.dbo.list l1
cross join (select sum(cast(count as numeric(18,2))) [count]
                 , sum([Avg Reads]) * sum(cast(count as numeric(18,2))) [Sum Avg Reads]
                 , sum([Max Reads]) * sum(cast(count as numeric(18,2))) [Sum Max Reads]
                 , sum([Avg Writes]) * sum(cast(count as numeric(18,2))) [Sum Avg Writes]
                 , sum([Max Writes]) * sum(cast(count as numeric(18,2))) [Sum Max Writes]
                 , sum([Avg CPU]) * sum(cast(count as numeric(18,2))) [Sum Avg CPU]
                 , sum([Max CPU]) * sum(cast(count as numeric(18,2))) [Sum Max CPU]
                 , sum([Avg Duration]) * sum(cast(count as numeric(18,2))) [Sum Avg Duration]
                 , sum([Max Duration]) * sum(cast(count as numeric(18,2))) [Sum Max Duration]
              from admin.dbo.list
              where SQL not like 'TOTAL %') l2
where l1.SQL = 'AVIndex_lookup_replace'
 not like 'TOTAL %'
order by [% Avg Duration] desc